You are viewing the RapidMiner Studio documentation for version 10.1 - Check here for latest version
Get Excel Sheet Names (Operator Toolbox)
Synopsis
This operator takes an Excel file and returns the list of sheets which are in this file.Description
A file can either be provided as a path or as a file object on the input port. The result is an ExampleSet with two attributes: Sheet Number and Sheet Name.Input
- fil (File)
The excel file which should be used. This is not mandatory. File objects can be generated with operators like Open File or Loop Files.
Output
- exa (Data Table)
The ExampleSet with the sheet names and numbers.
Parameters
- file_nameThe path to the Excel file. Range: configurable
Tutorial Processes
Read Sheet Names
In this example we generate an excel file and extract the sheet names of this generated file again using the file input port.